DateDiff(datepart, date1, date2)Returns the number of intervals in whole units of type Datepart by which Date1 is less than Date2.
See also DateAdd, DatePart, and CreateTimeSpan.
One of the following strings:
yyyy
-- Year
q
-- Quarter
m
-- Month
y
-- Day of year
d
-- Day
w
-- Weekday
ww
-- Week
h
-- Hour
n
-- Minute
s
-- Second
Date/time object in the period from 100 AD to 9999 AD.
Date/time object in the period from 100 AD to 9999 AD.